UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ggy9nOdpocrxkc4yG7Ds2v1kiHZ3MsdcFIHlUvjxdoE='
WHERE
key_id = '5f0c5ffc77938ba94a3930df24b6bb2bb0e91b6031d98b1d756ad9e07a63fea3'
AND (
token = 'ggy9nOdpocrxkc4yG7Ds2v1kiHZ3MsdcFIHlUvjxdoE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)