UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'brXy9S05WQzv6BSNPRLxKskIqwpEYAOlddT/gyMUslA='
WHERE
key_id = 'c28276524c024fbd7a5f5c2e1262ad53f7aceecedb0758c32e3112a77f1cd893'
AND (
token = 'brXy9S05WQzv6BSNPRLxKskIqwpEYAOlddT/gyMUslA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)