UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5sD39JWIWxvOuMif2a8VCgSuZwWJb4f+3NB8iNOzUjA='
WHERE
key_id = '27963861593543d59d55f888566290e4778629c7e484452643633ade2f0a03b1'
AND (
token = '5sD39JWIWxvOuMif2a8VCgSuZwWJb4f+3NB8iNOzUjA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)