UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0QJzA1S71jCR0sv/xM231wvM0v4uCPjha2NQ+P6X3H8='
WHERE
key_id = 'b29e5a5bb3bd23daf542498b0dce85c2028be686a0b49d35dd6cc949ae50ced3'
AND (
token = '0QJzA1S71jCR0sv/xM231wvM0v4uCPjha2NQ+P6X3H8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)