UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WNzj8702FHEpkcEsGbrSQ9hufkvQaHwHgdDEXJNiCmA='
WHERE
key_id = 'ab94f2a538dd98f3a1c28d0360e59ea741b45f65adcabb4f1cd202aacaee9578'
AND (
token = 'WNzj8702FHEpkcEsGbrSQ9hufkvQaHwHgdDEXJNiCmA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)