UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Q47MBBpQ0MaaWlZm8yuJ0rVlc8q6TQQAx4CEPX90/No='
WHERE
key_id = 'f8c25835d011e1d32e648dabd2b59b9a8b3caf87a0daad8e03ad031a5fa36d1e'
AND (
token = 'Q47MBBpQ0MaaWlZm8yuJ0rVlc8q6TQQAx4CEPX90/No='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)