UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YY3QaaEgAn/kiNNw5oAHYhJORWvbvrwBT0xM4qFc9BE='
WHERE
key_id = 'de34f89d7f678c83cb8b3553689ea75a5779cad61e06750e67bfa6448859607a'
AND (
token = 'YY3QaaEgAn/kiNNw5oAHYhJORWvbvrwBT0xM4qFc9BE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)