UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xZ0tj5sX5T4VZrFSM6aud/eIv8nBzdsf3EmVAXv9dAM='
WHERE
key_id = '9e0f817ed2d88efcebd80ebb8b4269b405a9289cc55ab89eea8c75a3412762c1'
AND (
token = 'xZ0tj5sX5T4VZrFSM6aud/eIv8nBzdsf3EmVAXv9dAM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)