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