UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'A23wO1jifW7Pri5+RX98hVVjfrIzudG0eOLff+7gyPI='
WHERE
key_id = '8e1baa7f799446ce2c86ba4ceb12cbb5aec59595a6eefe4e190b0f58253793c2'
AND (
token = 'A23wO1jifW7Pri5+RX98hVVjfrIzudG0eOLff+7gyPI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)