UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nWEEqhmWcEQLJlgb5g6rZ0RrhFpmo8MCaG/RL7VpCmU='
WHERE
key_id = 'a0b798250bfc0cce8e1c18f8bb5cbda31299dd3704ff50397b09ee81cc64d7e7'
AND (
token = 'nWEEqhmWcEQLJlgb5g6rZ0RrhFpmo8MCaG/RL7VpCmU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)