UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Z5O/nnATh98Yf3C86F0nopUPr8MHqSe2VJ4Lr54yZlw='
WHERE
key_id = '9f1aea247fe159df744b7f032cfc354e922b544cb9120066f26d1a58d585b653'
AND (
token = 'Z5O/nnATh98Yf3C86F0nopUPr8MHqSe2VJ4Lr54yZlw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)