UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5AYBpkaFvzFqMYf/wDKm8iHvH0NL+B9oOL6k/EL5lSk='
WHERE
key_id = 'affea9efbbc5e1c7572b6902cb89745da12101300d8747ae344a20b259ac99a9'
AND (
token = '5AYBpkaFvzFqMYf/wDKm8iHvH0NL+B9oOL6k/EL5lSk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)