UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Mycr4dGLknK9WlTY46l5EUi20kHW2nYTrnc61Pba9Qs='
WHERE
key_id = 'd81d2b493cdc979931ee7d5bc2a57c208567170dde3f1f531b678a3056fe18dc'
AND (
token = 'Mycr4dGLknK9WlTY46l5EUi20kHW2nYTrnc61Pba9Qs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)