UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XCL78n5TpvIrcwLJaY6SfpiE9siXDVFthjd0A5snVEU='
WHERE
key_id = '37cf14230c05e58829742acab4343961058c230f079c66dd085c2242f3170ed6'
AND (
token = 'XCL78n5TpvIrcwLJaY6SfpiE9siXDVFthjd0A5snVEU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)