UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QYxaZppG7Qgd1RxRJbe0engHrTWBn5hvOU+qq64sf4w='
WHERE
key_id = 'e132ac53534e9ad3ad9cc21b9edc86f9bc6db1ec6783c30946ee44f26067199c'
AND (
token = 'QYxaZppG7Qgd1RxRJbe0engHrTWBn5hvOU+qq64sf4w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)