UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dM57yjDmrW8GjIkUdz3Zh1yJhmzkkBPr9BNBhO62CTs='
WHERE
key_id = '2a7cdc9ff6122ecf57b1988a5f4b8a45e46020959eb3b107e849f66d7a651347'
AND (
token = 'dM57yjDmrW8GjIkUdz3Zh1yJhmzkkBPr9BNBhO62CTs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)