UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0kCyKGZOOobV5oOu7Xwr54hNrWpMNJglfaNSXbo7YzY='
WHERE
key_id = 'e099df6dd625a83b7f4795618fa03bdfc5c199f7510b15fb9704cfbfe86ea54f'
AND (
token = '0kCyKGZOOobV5oOu7Xwr54hNrWpMNJglfaNSXbo7YzY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)