UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'i0kAL1XylmRJba7zIFs8I2+aTeGSN+WFOV96FuYnfS8='
WHERE
key_id = '4c01f5c43de9ddc5f0d81b3acaf81032779eeec35fcb604d75c743bee83a0261'
AND (
token = 'i0kAL1XylmRJba7zIFs8I2+aTeGSN+WFOV96FuYnfS8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)