UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iotdBFN0CSrtATH4GzJhu9YXOBhCXxqJWC4P5GrzI1M='
WHERE
key_id = 'fa983905490899b8961eaf41a2a91c01bc548b61925a89f1f7112ca960abf7ff'
AND (
token = 'iotdBFN0CSrtATH4GzJhu9YXOBhCXxqJWC4P5GrzI1M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)