UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7e2sa1IhUzWBnD3pNdUoN/XZ4tNNYb9WQ24NSuHtNqw='
WHERE
key_id = 'b008c295c8dc1c33590e09abdbada5da32b7787652e3b77c59c436c52b173e9c'
AND (
token = '7e2sa1IhUzWBnD3pNdUoN/XZ4tNNYb9WQ24NSuHtNqw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)