UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'l5miEmQHH8LU5P4gGUO/Fk1BUvafhbLv0vG/9U+yOX4='
WHERE
key_id = 'c8473e32f5d7cc05a106d6fc9be96ced5cc898b98045c148d9ad743efa8fe47d'
AND (
token = 'l5miEmQHH8LU5P4gGUO/Fk1BUvafhbLv0vG/9U+yOX4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)