UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3EsdwX4d0TtsjV98o6eXdTGdu3labit5N1Y1gLAzJ/8='
WHERE
key_id = '1adea9a2438580f67dc0a1163ae1df0fb648b8b6f859f060a43be530c68ecb9e'
AND (
token = '3EsdwX4d0TtsjV98o6eXdTGdu3labit5N1Y1gLAzJ/8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)