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