UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aKP1J31wxPpBUWYfTGb+TxRsakG3rjT6PWHHE8bGfk8='
WHERE
key_id = 'caccc030c70d6c07ad3cfae37bd846b7e87c9333ebac866fdbba8e7c0c7ad81a'
AND (
token = 'aKP1J31wxPpBUWYfTGb+TxRsakG3rjT6PWHHE8bGfk8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)