UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'S6Prmt93g1zZXULl0YIEtLUowKqlK0VcW1V6GtT8dGU='
WHERE
key_id = '6e9c47b25c932096da3ec3de9909df5ac730a1a54efcbc8e22f132fdb8ec6795'
AND (
token = 'S6Prmt93g1zZXULl0YIEtLUowKqlK0VcW1V6GtT8dGU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)