UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zw0pILmGrFYY2TEOylQt4mlzK0Km+ysaD/zbVTI6trM='
WHERE
key_id = 'ec3fdd494b3ad00c7a8f6a4a504ed62df1ee16b53aca11d0e9e2f810823ceaec'
AND (
token = 'zw0pILmGrFYY2TEOylQt4mlzK0Km+ysaD/zbVTI6trM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)