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